Nic Larsen ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	41

About Me

About Me

Not much happening here, yet.

Analytics

524

Posts

2,440

Visits

11.4k

Points

Jun 26, 2018

Join Date

Feb 27, 2025

Last Active

Reactions

• Insightful 11

  11
• Vote Up 29

  29
• Awesome 57

  57

• Activity
• Discussions2
• Comments522

• Re: Task Status

  Nic Larsen

  09/13/24
  Try: =IF(ISDATE([Actual Date]@row), "Complete", IF([Target Date]@row > TODAY(), "Upcoming", IF(AND([Target Date]@row < TODAY(), ISBLANK([Actual Date]@row)), "Past Due&q…
  1 ·

• Re: Count based on Multiple Criteria & Dates

  Nic Larsen

  09/10/24
  The only thing that jumps out is the Dates. The way it reads is less than 1/1/24 and greater than 12/30/24… I'd swap the direction of the <>.
  1 ·

• Re: URGENT! Account access terming! How to offload/archive data for access outside of Smartsheet

  Nic Larsen

  02/21/24
  There's this option for requesting backups... Request a one-time backup | Smartsheet Learning Center
  1 ·

• Re: IF statement comparing today's date to a projected date

  Nic Larsen

  11/02/23
  Hmm. Is the date column setup as a date type column vs text/number? You can also just try retyping the formula vs copying/paste which has been known to cause issues in some cases.
  1 ·

• Re: Returning Harvey Balls after comparing dates in two columns

  Nic Larsen

  12/04/20
  I added a check to see if the 1st column is empty, if so, it'll just stay blank. If it is filled it will move on. Oops, I had the formula backwards subtracting 1st column from 2nd. I've switched that…
  1 ·

Next